SELECT loc_id, plz, name FROM (
SELECT
g1.loc_id AS loc_id,
g1.text_val AS plz,
g.text_val AS name
FROM geodb_hierarchies gh
INNER JOIN geodb_textdata g1 ON g1.loc_id = gh.loc_id AND g1.text_type = 500300000
INNER JOIN geodb_textdata g ON g.loc_id = gh.loc_id AND g.text_type = 500100000
WHERE gh.id_lvl2 = 105
AND g1.text_val LIKE 'Buchs (ZH)%'
UNION ALL
SELECT
g1.loc_id AS loc_id,
g1.text_val AS plz,
g.text_val AS name
FROM geodb_hierarchies gh
INNER JOIN geodb_textdata g1 ON g1.loc_id = gh.loc_id AND g1.text_type = 500300000
INNER JOIN geodb_textdata g ON g.loc_id = gh.loc_id AND g.text_type = 500100000
WHERE gh.id_lvl2 = 105
AND g.text_val LIKE 'Buchs (ZH)%'
AND g1.text_val NOT LIKE 'Buchs (ZH)%'
) combined
ORDER BY plz ASC
LIMIT 0,12
Personen aus Buchs (ZH) | mv-spion.de